UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sCDjSPVW6IxLvK2nVJg3ABWW/pNybi7dOrYS7ULw9J4='
WHERE
key_id = '5d402c98b294cb63664b875adbf17bd1a0713a2a17e0b79d4173f8e9538c9890'
AND (
token = 'sCDjSPVW6IxLvK2nVJg3ABWW/pNybi7dOrYS7ULw9J4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)