UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QdkCE47YrS0XQfFvews3/uTwqafg2hn/6C+x92zGYzA='
WHERE
key_id = '94676d661cfc6bc8df4f61fb9a1322b32912b583f625c6452e8e47d33bfc6300'
AND (
token = 'QdkCE47YrS0XQfFvews3/uTwqafg2hn/6C+x92zGYzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)