UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oS0hn7G8qJoFGzI11J7SsySzBVF+Ivl96jr6kVhgwaM='
WHERE
key_id = 'ddbaf2959bdb942b8a87c139fcf12bf557830de95cf08a59d0411c9a485533e3'
AND (
token = 'oS0hn7G8qJoFGzI11J7SsySzBVF+Ivl96jr6kVhgwaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)