UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YvGhUl7RTWlyReMyUZQrOvwwInVNU33je/xQpt9tHH8='
WHERE
key_id = '9cb6921f3a6c165a63405dccc763187029f2f68a12d185e1671543e3afd84135'
AND (
token = 'YvGhUl7RTWlyReMyUZQrOvwwInVNU33je/xQpt9tHH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)