UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dwTIMJtEUCHh1ZzhCY7DE3C8F0uJsPvh0vCkcoIUxH8='
WHERE
key_id = '49c215cb52a5d6197413f12d9e6f708b5e25c5018539c7ef8a3e299b5b538792'
AND (
token = 'dwTIMJtEUCHh1ZzhCY7DE3C8F0uJsPvh0vCkcoIUxH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)