UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6EDEIqjzNFW7WwnlFuQW9BG9CNmF/RvoFKKQ7UaeDN4='
WHERE
key_id = 'd379891a7e55659986fc4d2f3a53893acaed895a71e7bb384b07491788df8d3b'
AND (
token = '6EDEIqjzNFW7WwnlFuQW9BG9CNmF/RvoFKKQ7UaeDN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)