UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GR7lDZ8O020oBRN7jPmpn/rSoCzXw8gkD3sUH4czicQ=' 
WHERE 
  key_id = '78a5becb6fb5facbf2c59f14c93af55cfbaaf2d1fb64018653f4faacd1cb49c0' 
  AND (
    token = 'GR7lDZ8O020oBRN7jPmpn/rSoCzXw8gkD3sUH4czicQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029