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