UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Q7upNZny1rVP3BpwuF1fxVGSRoEZKf/ZLQICDK5mmVw=' 
WHERE 
  key_id = '9740b64f4cdc190f55ffa24dcc6d6a0ef95d28379e27e682d7d7b048b5547cd0' 
  AND (
    token = 'Q7upNZny1rVP3BpwuF1fxVGSRoEZKf/ZLQICDK5mmVw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026