UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uBOHSfMUgemIMn3mc6cEtKT1cfDfL/yKuUo1+uAytZU='
WHERE
key_id = '4e362268f391db7a45c2b50aee33516d46a84e50a44b7abc5278df89c644f9d5'
AND (
token = 'uBOHSfMUgemIMn3mc6cEtKT1cfDfL/yKuUo1+uAytZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)