UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEGZNFRgFvpXS3v5spSGrt9dP1hltckPA9+mix1lSoM='
WHERE
key_id = 'f76aa863870d72ac420a18d49e49b65bc7cbc80822a8d4f73f45ecbc357e59d5'
AND (
token = 'pEGZNFRgFvpXS3v5spSGrt9dP1hltckPA9+mix1lSoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)