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