UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+gtSYwXoEo4AGwT0Mi46EdQyHgsLrbpuz1Po+O4iOj4=' 
WHERE 
  key_id = '87a9591043374a876daa09423c068c99dfca1c8ca84d8ce0bec44b6e4fc04612' 
  AND (
    token = '+gtSYwXoEo4AGwT0Mi46EdQyHgsLrbpuz1Po+O4iOj4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040