UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BsDx/uWvIJ+8rTEA7zyqCbOPPWwgNCS29LCgfzkjxuw='
WHERE
key_id = 'd46a04e8681be5bae97fa382e48590c565a78e95c28aa9d15df87f3ec03ac07e'
AND (
token = 'BsDx/uWvIJ+8rTEA7zyqCbOPPWwgNCS29LCgfzkjxuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)