UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jSNHeLaTzh7zxywPzi+f+EN2/KJ/p7nXTFof+K3b784='
WHERE
key_id = '9dac2fbca58461d7974e124cc594295ec4779e702f1018d5fde915e07433b1de'
AND (
token = 'jSNHeLaTzh7zxywPzi+f+EN2/KJ/p7nXTFof+K3b784='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)