UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1OpbEYRghCiZKDB3nyPhoiUok01VttNdr5SfQMik0H8='
WHERE
key_id = 'fcc7450df7ed1764ac6bbf58a8a3391b3d6965d22a35cf71cac429c4f1c24e4e'
AND (
token = '1OpbEYRghCiZKDB3nyPhoiUok01VttNdr5SfQMik0H8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)