UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZbTUFyLPn1OI3d9jKWIKO1uhUqkgz7r5cC3t4XXxoHE='
WHERE
key_id = '1296cfee35d2d7074392e1333c94b5fea3eea44c2372a47ea19400246a2a350e'
AND (
token = 'ZbTUFyLPn1OI3d9jKWIKO1uhUqkgz7r5cC3t4XXxoHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)