UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Q9q+yngsRxrVNZO96sac2IMKFSgDdLE/87jW006K+M='
WHERE
key_id = 'a1c1e38b0901f9323eb0af46b8404953cf45aee716f622f6764267e10a868650'
AND (
token = '5Q9q+yngsRxrVNZO96sac2IMKFSgDdLE/87jW006K+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)