UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wNbV0PBzHC2UireOS8VaQmM/PfpoBZal6iNFfRXqw7w='
WHERE
key_id = '2578212ebb3e07457433b4afdbb996bf7ce9f366b787834da4ce4def41cbe98b'
AND (
token = 'wNbV0PBzHC2UireOS8VaQmM/PfpoBZal6iNFfRXqw7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)