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