UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pr5JLUaw9uvXvM0b21tY6KgeYPIPc9pMdAx1hwdc2Jw='
WHERE
key_id = '6e5cb123d47dddd0236ae5c27f7a9abc84ecb0547d5a359952ff75ba5b71e95d'
AND (
token = 'Pr5JLUaw9uvXvM0b21tY6KgeYPIPc9pMdAx1hwdc2Jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)