UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpM/ycDzRA3t65ZvRdNV8zun6sLzsou7VqyndSAX2HA='
WHERE
key_id = '2eebdd1ea9832301d2e44364fc8ee7309333326cfe32fce84e475b141f4a9f96'
AND (
token = 'XpM/ycDzRA3t65ZvRdNV8zun6sLzsou7VqyndSAX2HA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)