UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfkdWIQpZPi1+0v8NkAiV4J8dmecszWYQgj+vPCBvQM='
WHERE
key_id = '844d9722595c8a8ffceeaf8bbc9895036a52df4128a7b25332adbb12383cb318'
AND (
token = 'xfkdWIQpZPi1+0v8NkAiV4J8dmecszWYQgj+vPCBvQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)