UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Xm+Q1HaA19vefoKXUk0vYLNq4S7T8Uaw5UjHe53+9wU=' 
WHERE 
  key_id = '61ddec884097e1cdb47fcf1ef2ea74b3280aee8abdc45447d3ead519c4ad9008' 
  AND (
    token = 'Xm+Q1HaA19vefoKXUk0vYLNq4S7T8Uaw5UjHe53+9wU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026