UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'crDKvhp3160q32WDUx9uGtDhzSXJHDyKqyqSk4tbvMY='
WHERE
key_id = '149f0e3a2935a7c91a631d9a865346c88ae7f5bdc697df299c5dad817bf01f50'
AND (
token = 'crDKvhp3160q32WDUx9uGtDhzSXJHDyKqyqSk4tbvMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)