UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2uVXj11s0wdH9R9isMXCp5Ew9+ipt6nKQqpit2ISmeE=' 
WHERE 
  key_id = '38119b6ff6ac108cce6dcd49a4b6b89048fc1de4c5f90e9e181fb7a200986df2' 
  AND (
    token = '2uVXj11s0wdH9R9isMXCp5Ew9+ipt6nKQqpit2ISmeE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036