UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZVjDw0I90EizQTHt8mk4kBpYrsaMYmwJHxj8SeNuZ8='
WHERE
key_id = '3b7de20374dc3fcff45fd74bf46540bf44d1d2d4f83a8ae6c96ea5bf1219ca6c'
AND (
token = 'ZZVjDw0I90EizQTHt8mk4kBpYrsaMYmwJHxj8SeNuZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)