UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hqUy8nyO8MCJtL3CfQCZSMWjYUkivKxgW49JAHURark='
WHERE
key_id = '4b8ffc1c2305eac13f501e586991f029f722346fe4a2cb8611b7b6975b80caa1'
AND (
token = 'hqUy8nyO8MCJtL3CfQCZSMWjYUkivKxgW49JAHURark='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)