UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xUx7DeQf0TQ3OGdQs/NFM+drx7tBBso9Gxi6Zr7TcKM=' 
WHERE 
  key_id = 'f3257ae6c19832d887d5224953c7a85d15acf2525a648a25b5f4b6bb88792518' 
  AND (
    token = 'xUx7DeQf0TQ3OGdQs/NFM+drx7tBBso9Gxi6Zr7TcKM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00014