UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7VzyFVLaSNn8PWMfCEhFJmno1+340s/ukDIYzS4m0dE='
WHERE
key_id = 'bd99f1b54f1fedd8e0afae514973b9884e19c5d3038633b4550b3e14bc374d83'
AND (
token = '7VzyFVLaSNn8PWMfCEhFJmno1+340s/ukDIYzS4m0dE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)