UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zmgnFpxH2RlOAckCXObvm9TBEu/fFz9N2UhBiyitMsg='
WHERE
key_id = '8f525d74441ac3356520c955496ba05328739969ebbeec9cac70491b32457ef6'
AND (
token = 'zmgnFpxH2RlOAckCXObvm9TBEu/fFz9N2UhBiyitMsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)