UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EkNzQhoqJcFKSYc4w42im0KEJzlKKT0m5rrkGM9IpNU='
WHERE
key_id = '29e1226c146173c49a914ceb5fb48887bae823a66498f047b3f744696a12856d'
AND (
token = 'EkNzQhoqJcFKSYc4w42im0KEJzlKKT0m5rrkGM9IpNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)