UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WJikmofaql8lIhfdrofC0cWbR11b4YZjThodJ0N3cWE='
WHERE
key_id = 'ccc15783328559a292b60691f0ee1168432e80b5a8aaf25f0e7fd6be3cf97f16'
AND (
token = 'WJikmofaql8lIhfdrofC0cWbR11b4YZjThodJ0N3cWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)