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